County Profile for Columbia - 2017



County Controls Information

Cost Report Counts Population
Total Hospital Count 1 Total Population on July 31, 2017 0
Total Cost Reports Filed in 2017 1 Total Births 0
Total Cost Reports Submitted 0 Total Deaths 0
Total Cost Reports Settled 0 Net Population Natural Change 0
Total Cost Reports Reopened 1 Total International Migration 0
Total Cost Reports Ammended 0 Total Domestic Migration 0
Total Cost Reports Audited 0 Total Residual 0
Net Population Change 0

County Financial Statements - Worksheet G

Balance Sheet Income Statement
Current Assets 3,998,904 Total Charges 50,256,727
Fixed Assets 29,331,366 Contract Allowance 30,031,352
Other Assets 5,050,819 Operating Revenue 20,225,375
Total Assets 38,381,089 Operating Expenses 23,808,106
Current Liabilities 1,879,578 Operating Margin -3,582,731
Long Term Liabilities 708,194 Other Income 1,162,572
Total Equity 35,793,317 Other Expense 0
Total Liabilities and Equity 38,381,089 Net Profit or Loss -2,420,159

County Calculations

Per Discharge Statistics Per Bed Statistics Per Person Statistics
Revenue per Discharge $15,439 Revenue per Bed $777,899 Revenue per Person $20,225,375
Net Margin per Discharge ($2,735) Net Margin per Bed ($137,797) Net Margin per Person ($3,582,731)
Net Profit per Discharge ($1,847) Net Profit per Bed ($93,083) Net Profit per Person ($2,420,159)
Net Fixed Assets per Discharge $22,390 Net Fixed Assets per Bed $1,128,129 Net Fixed Assets per Bed $29,331,366
Long Term Debt per Discharge $541 Long Term Debt per Bed $27,238 Long Term Debt per Person $708,194
Persons per Discharge 0 Persons per Bed 0
Occupancy Rate 41.4 %
Length of Stay 3 Days

County Ranking of Selected Values

Income Statement Balance Sheet Statistics
Total Charges 1,807 Net Fixed Assets 1,211 Population Estimate 1,151
Total Revenue 1,878 Long Term Liabilities 1,894 Total Patient Discharges 1,392
Net Margin 2,483 Total Patient Beds 1,640
Net Profit or Loss 2,930

County Charges and Direct Cost - Worksheet B and C

Line Description Direct Cost Charges Ratio
30 Adults and Pediatrics - General Routine Care 5,272,547 3,086,061 1.7085
31 Intensive Care Unit 1,226,393 1,045,982 1.1725
32 Coronary Care Unit 0 0
43 Nursery 632,220 248,892 2.5401
44 Skilled Nursing Care 0 0
50 Operating Room 1,860,015 5,839,462 0.3185
51 Recovery Room 0 0
52 Labor and Delivery Room 243,998 783,372 0.3115

County General Service Cost - Worksheet A

Lines Description Amount Lines Description Amount
01 Capital Related - Building and Fixtures 2,780,497 13 Nursing Administration 532,610
02,03 Captial Related - Movable Equipment 877,783 14 Central Services and Supply 116,934
04 Employee Benefits 2,157,564 15 Pharmacy 0
05 Administrative and General 2,556,301 16 Medical Records and Medical Library 346,587
06 Maintenance and Repairs 776,940 17 Social Services 0
07 Operation of Plant 0 18 Other General Service Expense 0
08,09 Laundry, Linen and Housekeeping 589,431 19 Non Physician Anesthetist 0
10,11 Dietary and Cafeteria 272,362 20,21,22,23 Education Programs 561,003
Total General Service Cost Centers 11,568,012

County Profile for Columbia - 2017